UCSF

Parameters Provided:

name.synonym = 1-Heptanecarboxylate;1-Heptanecarboxylic acid;Caprylate;Caprylic acid;Emery 657;Kortacid 0899;Lunac 8-95;Lunac 8-98;N-Caprylate;N-Caprylic acid;N-Octanoate;N-Octanoic acid;N-Octoate;N-Octoic acid;N-Octylate;N-Octylic acid;Neo-Fat 8;Neo-Fat 8S;Octylate;Oct
filter.purchasability = all
page.num = 1

Structural Results Found: (before additional filtering)

SQL Query Was

SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id  WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE '1-Heptanecarboxylate;1-Heptanecarboxylic acid;Caprylate;Caprylic acid;Emery 657;Kortacid 0899;Lunac 8-95;Lunac 8-98;N-Caprylate;N-Caprylic acid;N-Octanoate;N-Octanoic acid;N-Octoate;N-Octoic acid;N-Octylate;N-Octylic acid;Neo-Fat 8;Neo-Fat 8S;Octylate;Oct' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id  WHERE c.free = 1   )    LIMIT 50

Permalink

//zinc12.docking.org/results/combination?name.synonym=1-Heptanecarboxylate%3B1-Heptanecarboxylic+acid%3BCaprylate%3BCaprylic+acid%3BEmery+657%3BKortacid+0899%3BLunac+8-95%3BLunac+8-98%3BN-Caprylate%3BN-Caprylic+acid%3BN-Octanoate%3BN-Octanoic+acid%3BN-Octoate%3BN-Octoic+acid%3BN-Octylate%3BN-Octylic+acid%3BNeo-Fat+8%3BNeo-Fat+8S%3BOctylate%3BOct&filter.purchasability=all

Embed Link to Results